cd c:
cd \SSISPackageForCollectingSSAS_DMVData
SET DataCollectionServer=DataCollectionServer
SET SSASServer=SSASServer
SET SSASServerInstance=SSASServerInstance
SET DTEXEC_PATH=C:\Program Files\Microsoft SQL Server\100\DTS\Binn\
SET DataFilePath=C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\
SET LogFilePath=C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\
SET JobOwner=sa
SET Read_SSAS_DMV_Path=C:\SSISPackageForCollectingSSAS_DMVData\
SET ReadSSASDMVJobSchedule=60

sqlcmd -S %DataCollectionServer% -i drop_and_create_db_dmv.sql -i add_schemas_db_dmv.sql -i SSASDMVConnection.sql -i SSASDMVSession.sql -i SSASDMVCommand.sql -i ssas_connections.sql -i ssas_sessions.sql -i ssas_commands.sql -i ssas_command_objects.sql -i ssas_object_activity.sql -i ssas_memory_usage.sql -i SSAS_DMVs.sql 

pause